{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Selection","Data&Rules","RMXS Capacity","Results","Report","FlowChart","T&C"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":18,"comments":1,"pivot_tables":3},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Selection","index":0,"n_rows":34,"n_cols":28,"rows_kept":34,"cut":false,"hidden":false,"merged":[[29,4,29,5],[28,4,28,5],[27,4,27,5],[26,22,26,23],[29,6,29,7],[28,9,28,13],[1,8,1,25],[23,15,23,16],[23,22,23,23],[21,10,21,13],[20,10,20,11],[12,5,12,8],[11,5,11,6],[8,15,8,16],[16,1,17,7],[21,4,21,5],[20,4,20,5],[5,22,5,23],[8,22,8,23],[11,22,11,23],[14,1,15,3],[6,29,6,31],[26,6,26,7],[27,6,27,7],[28,6,28,7],[14,22,14,23],[17,22,17,23],[24,5,24,6],[20,22,20,23],[17,15,17,16],[22,4,22,5]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!P3","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q3","v":"."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q46=0,\"\",'Data&Rules'!Q46)","v":"x"},null,null,null,null,null,null,{"$f":"'Data&Rules'!P5","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q5","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!O46","v":"N/A"}]
[null,null,null,null,null,16.399999999999999,"ft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft"]
[null,null,null,null,null,{"$f":"IF('Data&Rules'!S55=\"\",\"\",'Data&Rules'!S55)","v":"3/8\"x3/4\""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!P7","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q7","v":"."}]
[null,null,null,null,null,{"$f":"IF('Data&Rules'!T55=\"\",\"\",'Data&Rules'!T55)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft"]
[null,"RMXS48LVJU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!P9","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q9","v":"."}]
[]
[null,"Selection Check",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q47=0,\"\",'Data&Rules'!Q47)","v":"x"},null,null,null,null,null,null,{"$f":"'Data&Rules'!P11","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q11","v":"."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!O47","v":"N/A"}]
[null,"Total number of Indoor Units",null,null,null,{"$f":"IF('Data&Rules'!N19=0,\" \",'Data&Rules'!N19)","v":" "},null,null,null,null,null,"ft",null,null,null,null,null,null,null,null,null,null,null,"ft"]
[null,"Total IU Capacity",null,null,{"$f":"'Data&Rules'!$C$109","v":" "},null,null,"MBH",null,null,{"$f":"'Data&Rules'!S56","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!P13","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q13","v":"."}]
[null,"Available Cooling Capacity",null,null,{"$f":"IF(E21=\" \",\" \",'Data&Rules'!$M$109)","v":" "},null,null,"MBH",null,null,{"$f":"IF('Data&Rules'!T56=\"\",\"\",'Data&Rules'!T56)","v":""}]
[null,"Available Heating Capacity",null,null,{"$f":"IF(E21=\" \",\" \",'Data&Rules'!$N$109)","v":" "},null,null,"MBH",null,null,null,null,null,null,null,null,"ft",null,null,null,null,null,null,"ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!Q48","v":"x"},null,null,null,null,null,null,{"$f":"'Data&Rules'!P15","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q15","v":"."}]
[null,"Connection ratio",null,null,null,{"$f":"'Data&Rules'!$D$109","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!O48","v":"N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ft"]
[null,"Total Piping Length (Liquid)",null,null,null,{"$f":"'Data&Rules'!K64","v":16.399999999999999},"ft..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Data&Rules'!P17","v":"x"},null,null,null,null,{"$f":"'Data&Rules'!Q17","v":"."}]
[null,"Standard Ref Charge :",null,null,8.8000000000000007,null,"lbs"]
[null,"Add'l Ref Charge",null,null,{"$f":"'Data&Rules'!$O$114","v":0.59039999999999992},null,"lbs",null,null,"Errors",null,null,null,null,{"$f":"'Data&Rules'!R64","v":""}]
[null,"Total Ref Charge",null,null,{"$f":"IF(E21=\" \",\" \",E29+E28)","v":" "},null,"lbs",null,null,null,{"$f":"IF('Data&Rules'!Q63=\"\",\"\",'Data&Rules'!Q63)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q64=\"\",\"\",'Data&Rules'!Q64)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q65=\"\",\"\",'Data&Rules'!Q65)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q66=\"\",\"\",'Data&Rules'!Q66)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Data&Rules'!Q67=\"\",\"\",'Data&Rules'!Q67)","v":""}]

{"sheet":"Data&Rules","index":1,"n_rows":119,"n_cols":20,"rows_kept":119,"cut":false,"hidden":false,"merged":[[118,10,119,13],[108,8,108,9],[108,10,108,11],[108,4,108,5],[108,6,108,7],[90,2,90,3],[91,2,91,3],[107,4,107,5],[107,6,107,7],[107,8,107,9],[98,2,98,3],[99,2,99,3],[100,2,100,3],[101,2,101,3],[102,2,102,3],[93,2,93,3],[94,2,94,3],[95,2,95,3],[96,2,96,3],[97,2,97,3],[85,1,86,1],[85,2,86,3],[87,1,88,1],[87,2,88,3],[0,6,0,8],[43,6,43,8],[52,6,52,8],[66,2,67,3],[66,4,67,5],[64,2,65,3],[64,4,65,5],[0,3,0,5],[43,3,43,5],[52,3,52,5],[113,14,116,14],[112,1,116,3],[68,2,75,3],[76,1,76,3],[77,2,84,3],[77,1,84,1],[63,1,75,1],[63,2,63,3],[63,4,63,5],[107,10,107,11],[92,2,92,3],[89,1,92,1],[89,2,89,3],[103,2,103,3],[93,1,104,1],[104,2,104,3]]}
[null,"Indoor Unit","Capacity","Pipe Dimensions",null,null,"Type",null,null,null,null,"IU Items","Model","Selected  IU","Capacity","Pipe Dimensions","Type","Pipe Lengths"]
[1,null,null,"Gas","Liquid","x","."]
[2,"Ducted- FDXS09LVJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","Slim Ducted Unit ",null,null,null,null,"IU-1",{"$f":"VLOOKUP(N3,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N3,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N3,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N3,$A$2:$G$36,7)","v":"."},{"$f":"IU1Pipe","v":0}]
[3,"Ducted- FDXS12LVJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","Slim Ducted Unit "]
[4,"Ducted- CDXS15LVJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","Slim Ducted Unit ",null,null,null,null,"IU-2",{"$f":"VLOOKUP(N5,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N5,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N5,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N5,$A$2:$G$36,7)","v":"."},{"$f":"IU2Pipe","v":0}]
[5,"Ducted- CDXS18LVJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","Slim Ducted Unit "]
[6,"Ducted- CDXS24LVJU",24000," 5/8\" ","1/4\"","1/4\"x5/8\"","Slim Ducted Unit ",null,null,null,null,"IU-3",{"$f":"VLOOKUP(N7,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N7,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N7,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N7,$A$2:$G$36,7)","v":"."},{"$f":"IU3Pipe","v":0}]
[7,"Wall- CTXG09QVJUS",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","EMURA Silver"]
[8,"Wall- CTXG12QVJUS",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","EMURA Silver",null,null,null,null,"IU-4",{"$f":"VLOOKUP(N9,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N9,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N9,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N9,$A$2:$G$36,7)","v":"."},{"$f":"IU4Pipe","v":0}]
[9,"Wall- CTXG18QVJUS",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","EMURA Silver"]
[10,"Wall- CTXG09QVJUW",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","EMURA White",null,null,null,null,"IU-5",{"$f":"VLOOKUP(N11,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N11,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N11,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N11,$A$2:$G$36,7)","v":"."},{"$f":"IU5Pipe","v":0}]
[11,"Wall- CTXG12QVJUW",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","EMURA White"]
[12,"Wall- CTXG18QVJUW",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","EMURA White",null,null,null,null,"IU-6",{"$f":"VLOOKUP(N13,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N13,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N13,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N13,$A$2:$G$36,7)","v":"."},{"$f":"IU6Pipe","v":0}]
[13,"Wall- CTXS07LVJU",7000," 3/8\" ","1/4\"","1/4\"x3/8\"","Wall Mounted Unit "]
[14,"Wall- FTXS09LVJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","Wall Mounted Unit ",null,null,null,null,"IU-7",{"$f":"VLOOKUP(N15,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N15,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N15,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N15,$A$2:$G$36,7)","v":"."},{"$f":"IU7Pipe","v":0}]
[15,"Wall- FTXS12LVJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","Wall Mounted Unit "]
[16,"Wall- FTXS15LVJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","Wall Mounted Unit ",null,null,null,null,"IU-8",{"$f":"VLOOKUP(N17,$A$2:$C$36,2)","v":0},1,{"$f":"VLOOKUP(N17,$A$2:$C$36,3)","v":0},{"$f":"VLOOKUP(N17,$A$2:$F$36,6)","v":"x"},{"$f":"VLOOKUP(N17,$A$2:$G$36,7)","v":"."},{"$f":"IU8Pipe","v":0}]
[17,"Wall- FTXS18LVJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","Wall Mounted Unit "]
[18,"Wall- FTXS24LVJU",24000," 5/8\" ","1/4\"","1/4\"x5/8\"","Wall Mounted Unit ",null,null,null,null,"Total",null,{"$f":"COUNTIF(N3:N17,\">1\")","v":0},{"$f":"SUM(O3:O17)","v":0},null,{"$f":"COUNTIF(Q3:Q17,\"Slim Ducted Unit\")","v":0},{"$f":"SUM(R3:R17)","v":0}]
[19,"Cassette- FFQ09Q2VJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","VISTA Cassette"]
[20,"Cassette- FFQ12Q2VJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","VISTA Cassette"]
[21,"Cassette- FFQ15Q2VJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","VISTA Cassette"]
[22,"Cassette- FFQ18Q2VJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","VISTA Cassette"]
[23,"Cassette- FFQ09LVJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","2X2 Ceiling Cassette "]
[24,"Cassette- FFQ12LVJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","2X2 Ceiling Cassette "]
[25,"Cassette- FFQ15LVJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","2X2 Ceiling Cassette "]
[26,"Cassette- FFQ18LVJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","2X2 Ceiling Cassette "]
[27,"Floor- FVXS09NVJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","Floor Standing Unit "]
[28,"Floor- FVXS12NVJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","Floor Standing Unit "]
[29,"Floor- FVXS15NVJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","Floor Standing Unit "]
[30,"Floor- FVXS18NVJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","Floor Standing Unit "]
[31,"Ducted- FDMQ09RVJU",9000," 3/8\" ","1/4\"","1/4\"x3/8\"","Ducted Concealed Unit"]
[32,"Ducted- FDMQ12RVJU",12000," 3/8\" ","1/4\"","1/4\"x3/8\"","Ducted Concealed Unit"]
[33,"Ducted- FDMQ15RVJU",15000," 1/2\" ","1/4\"","1/4\"x1/2\"","Ducted Concealed Unit"]
[34,"Ducted- FDMQ18RVJU",18000," 1/2\" ","1/4\"","1/4\"x1/2\"","Ducted Concealed Unit",null,null,null,null,null,null,1]
[35,"Ducted- FDMQ24RVJU",24000," 5/8\" ","1/4\"","1/4\"x5/8\"","Ducted Concealed Unit",null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[]
[]
[]
[]
[]
[null,"BP Boxes","Ports","Pipe Dimensions",null,null,"Upsized Pipe ",null,null,"Description","Max Cap",null,"BP Items","Selected Port","BP Box Names","Total Indoor Capacity","Pipe Dimensions","Pipe Lengths"]
[null,null,null,"Gas","Liquid","x","Gas","Liquid","x",null,null,null,null,null,null,null,null,null,"x"]
[1,"N/A","0 Ports",null,"N/A","x",null,"N/A","x",null,null,null,"BP-1",1,{"$f":"VLOOKUP(N46,$A$45:$F$48,2)","v":"N/A"},{"$f":"O3+O5+O7","v":0},{"$f":"IF(P46>17000,VLOOKUP(N46,$A$45:$I$48,9),VLOOKUP(N46,$A$45:$I$48,6))","v":"x"},{"$f":"Selection!P8","v":0}]
[2,"BPMKS048A2U","2 Ports","1/2\"","1/4\"",{"$f":"E47&$F$2&D47","v":"1/4\"x1/2\""},"5/8\"","3/8\"",{"$f":"H47&$F$2&G47","v":"3/8\"x5/8\""},"2 zone BP Box",48000,null,"BP-2",1,{"$f":"VLOOKUP(N47,$A$45:$F$48,2)","v":"N/A"},{"$f":"O9+O11+O13","v":0},{"$f":"IF(P47>17000,VLOOKUP(N47,$A$45:$I$48,9),VLOOKUP(N47,$A$45:$I$48,6))","v":"x"},{"$f":"Selection!P17","v":0}]
[3,"BPMKS049A3U","3 Ports","1/2\"","1/4\"",{"$f":"E48&$F$2&D48","v":"1/4\"x1/2\""},"5/8\"","3/8\"",{"$f":"H48&$F$2&G48","v":"3/8\"x5/8\""},"3 zone BP Box",62000,null,"BP-3",1,{"$f":"VLOOKUP(N48,$A$45:$F$48,2)","v":"N/A"},{"$f":"O15+O17","v":0},{"$f":"IF(P48>17000,VLOOKUP(N48,$A$45:$I$48,9),VLOOKUP(N48,$A$45:$I$48,6))","v":"x"},{"$f":"Selection!P23","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R46:R48)","v":0}]
[]
[]
[null,"REFNETS",null,"Pipe Dimensions",null,null,"Upsized Pipe ",null,null,null,null,null,"OU Items","Capacity",1.3,"Total Indoor Capacity","Capacity","Pipe Lengths"]
[null,null,null,"Gas","Liquid","x","Gas","Liquid","x",null,null,null,null,null,null,null,48000,null,"Size","Model"]
[1,"KHRP26A22T","Main Refnet","3/4\"","3/8\"",{"$f":"E55&$F$2&D55","v":"3/8\"x3/4\""},null,null,null,null,null,null,"RMXS48LVJU",48000,{"$f":"N55*1.3","v":62400},{"$f":"SUM(P46:P48)","v":0},"Check/Error",{"$f":"MainRef","v":16.399999999999999},"3/8\"x3/4\""]
[2,"KHRP26A22T","2nd Refnet","5/8\"","3/8\"",{"$f":"E56&$F$2&D56","v":"3/8\"x5/8\""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"Selection!K20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R55:R56)","v":16.399999999999999}]
[]
[]
[null,"Rules",null,null,null,null,null,"Maximum Allowed",null,null,"Selected Input",null,null,"Check/Error"]
[]
[]
[null,"Maximum Allowable Length","Total Piping Length",null,"Total Piping",null,null,440,null,null,{"$f":"R19+R50+R58","v":16.399999999999999},null,null,{"$f":"IF(K64>H64,O64,\"\")","v":""},"Total Piping Length of the System exceeds 440 ft. Please check your check your Selection.",null,null,{"$f":"IF(OR(N94<>\"\",N95<>\"\",N96<>\"\",N96<>\"\",N97<>\"\",N98<>\"\",N99<>\"\",N100<>\"\",N101<>\"\",N102<>\"\",N103<>\"\",N104<>\"\",N105<>\"\"),O94,\"\")","v":""}]
[null,null,"Between OU and BP boxes",null,"Total Piping Length",null,null,180,null,null,{"$f":"R55+R56+R46+R47+R48","v":16.399999999999999},null,null,{"$f":"IF(K65>H65,O65,\"\")","v":""},"Total Piping Length between Outdoor Unit and BP Boxes exceeds 180 ft. Please check your Selection."]
[]
[null,null,"Between BP and indoor units",null,"Total Piping Length",null,null,262,null,null,{"$f":"R19","v":0},null,null,{"$f":"IF(K67>H67,O67,\"\")","v":""},"Total Piping Length between BP Boxes and Indoor Units exceeds 262 ft. Please check your Selection."]
[]
[null,null,"Between BP and indoor unit",null,"1 room length",null,null,49,null,null,{"$f":"R3","v":0},null,null,{"$f":"IF(K69>H69,O69,\"\")","v":""},"Piping Length between BP-1 and IU-1 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R5","v":0},null,null,{"$f":"IF(K70>H70,O70,\"\")","v":""},"Piping Length between BP-1 and IU-2 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R7","v":0},null,null,"","Piping Length between BP-1 and IU-3 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R9","v":0},null,null,"","Piping Length between BP-2 and IU-4 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R11","v":0},null,null,"","Piping Length between BP-2 and IU-5 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R13","v":0},null,null,"","Piping Length between BP-2 and IU-6 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R15","v":0},null,null,"","Piping Length between BP-3 and IU-7 exceeds 49 ft. Please check your Selection."]
[null,null,null,null,"1 room length",null,null,49,null,null,{"$f":"R17","v":0},null,null,"","Piping Length between BP-3 and IU-8 exceeds 49 ft. Please check your Selection."]
[null,"Minimum Allowable Length",null,null,"Piping Length",null,null,16.399999999999999,null,null,{"$f":"R55","v":16.399999999999999},null,null,{"$f":"IF(K77<H77,O77,\"\")","v":""},"Piping Length between Outdoor Unit and 1st Refnet is < 16.4 ft. Please check your Selection."]
[null,"Allowable length after first branch kit","Between Refnets and indoor unit",null,"Piping Length",null,null,131,null,null,{"$f":"R46+R3","v":0},null,null,{"$f":"IF(K78>H78,O78,\"\")","v":""},"Piping Length between Refnet and IU-1 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R46+R5","v":0},null,null,"","Piping Length between Refnet and IU-2 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R46+R7","v":0},null,null,"","Piping Length between Refnet and IU-3 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R56+R47+R9","v":0},null,null,"","Piping Length between Refnet and IU-4 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R56+R47+R11","v":0},null,null,"","Piping Length between Refnet and IU-5 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R56+R47+R13","v":0},null,null,"","Piping Length between Refnet and IU-6 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R56+R48+R15","v":0},null,null,"","Piping Length between Refnet and IU-7 exceeds 131 ft. Please check your Selection."]
[null,null,null,null,"Piping Length",null,null,131,null,null,{"$f":"R56+R48+R17","v":0},null,null,"","Piping Length between Refnet and IU-8 exceeds 131 ft. Please check your Selection."]
[null,"Maximum Capacity","Outdoor Unit",null,"Cooling Capacity",null,null,62400,null,null,{"$f":"O19","v":0},null,null,"","Maximum Allowable Connection ratio for the system is 130%. Please check your Selection."]
[null,null,null,null,"Heating Capacity",null,null,70200,null,null,"N/A",null,null,null,"Error 12"]
[null,"Minimum Capacity","Outdoor Unit",null,"Cooling Capacity",null,null,24000,null,null,{"$f":"O19","v":0},null,null,{"$f":"IF(K88<H88,O88,\"\")","v":"Minimum Allowable Connection ratio for the system is 50%. Please check your Selection."},"Minimum Allowable Connection ratio for the system is 50%. Please check your Selection."]
[null,null,null,null,"Heating Capacity",null,null,27000,null,null,"N/A",null,null,null,"Error 14"]
[null,"IU selection on BP units","Between BP-I and IUs",null,"Count Indoor Unit",null,null,null,null,null,{"$f":"IF(AND(N46>1,N3=1,N5=1,N7=1),0,\"OK\")","v":"OK"},null,null,{"$f":"IF(K90=0,O90,\"\")","v":""},"No Indoor Unit selected on BP-1. Please check your Selection."]
[null,null,"Between BP-2 and IUs",null,"Count Indoor Unit",null,null,null,null,null,{"$f":"IF(AND(N47>1,N9=1,N11=1,N13=1),0,\"OK\")","v":"OK"},null,null,{"$f":"IF(K91=0,O91,\"\")","v":""},"No Indoor Unit selected on BP-2. Please check your Selection."]
[null,null,"Between BP-3 and IUs",null,"Count Indoor Unit",null,null,null,null,null,{"$f":"IF(AND(N48>1,N15=1,N17=1),0,\"OK\")","v":"OK"},null,null,{"$f":"IF(K92=0,O92,\"\")","v":""},"No Indoor Unit selected on BP-3. Please check your Selection."]
[null,null,"Minimum Indoor Units",null,"Count Indoor Unit",null,null,2,null,null,{"$f":"N19","v":0},null,null,{"$f":"IF(K93<H93,O93,\"\")","v":"Minimum Allowable Indoor Units for the system is 2. Please check your Selection."},"Minimum Allowable Indoor Units for the system is 2. Please check your Selection."]
[null,"Warning","Pipe length on IU-1",null,"Piping Length",null,null,{"$f":"Selection!W5","v":0},null,null,{"$f":"N3","v":1},null,null,{"$f":"IF(AND(H94=0,K94<>1),O94,\"\")","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-2",null,"Piping Length",null,null,{"$f":"Selection!W8","v":0},null,null,{"$f":"N5","v":1},null,null,{"$f":"IF(AND(H95=0,K95<>1),O95,\"\")","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-3",null,"Piping Length",null,null,{"$f":"Selection!W11","v":0},null,null,{"$f":"N7","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-4",null,"Piping Length",null,null,{"$f":"Selection!W14","v":0},null,null,{"$f":"N9","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-5",null,"Piping Length",null,null,{"$f":"Selection!W17","v":0},null,null,{"$f":"N11","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-6",null,"Piping Length",null,null,{"$f":"Selection!W20","v":0},null,null,{"$f":"N13","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-7",null,"Piping Length",null,null,{"$f":"Selection!W23","v":0},null,null,{"$f":"N15","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on IU-8",null,"Piping Length",null,null,{"$f":"Selection!W26","v":0},null,null,{"$f":"N17","v":1},null,null,"","Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on BP-1",null,"Piping Length",null,null,{"$f":"Selection!P8","v":0},null,null,{"$f":"N46","v":1},null,null,{"$f":"IF(AND(H102=0,K102>1),IF(OR(H102=0,R55=0),IF(AND(K103=1,K104=1),\"\",O102),\"\"),\"\")","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on BP-2",null,"Piping Length",null,null,{"$f":"Selection!P17","v":0},null,null,{"$f":"N47","v":1},null,null,{"$f":"IF(AND(H103=0,K103>1),IF(OR(H103=0,R55=0),IF(AND(K102=1,K104=1),\"\",O103),\"\"),\"\")","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on BP-3",null,"Piping Length",null,null,{"$f":"Selection!P23","v":0},null,null,{"$f":"N48","v":1},null,null,{"$f":"IF(AND(H104=0,K104>1),IF(OR(H104=0,R55=0),IF(AND(K102=1,K103=1),\"\",O104),\"\"),\"\")","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[null,null,"Pipe length on Refnet-2",null,"Piping Length",null,null,{"$f":"Selection!K20","v":0},null,null,{"$f":"IF(AND(N47>1,N48>1),1,0)","v":0},null,null,{"$f":"IF(AND(H105=0,K105=0),\"\",IF(AND(H105<>0,K105<>0),\"\",IF(AND(K105<>0,MainRef<>0),\"\",O105)))","v":""},"Warning: Not all Pipe lengths are entered. Add'l Refrigerant Charge Calculation may not be correct."]
[]
[]
[null,"OU Nominal Cap (MBH)","Total IU Cap (MBH)","CR %","OU C-Capacity (Non-Ducted IU)",null,"OU H-Capacity (Non-Ducted IU)",null,"OU C-Capacity (Ducted IU)",null,"OU H-Capacity (Ducted IU)",null,"OU C-Capacity (Total)","OU H-Capacity (Total)"]
[null,48,{"$f":"IF(OR($K$86>$H$86,$K$88<$H$88),\" \",$K$86/1000)","v":" "},{"$f":"($K$86/1000)/B109","v":0},{"$f":"'RMXS Capacity'!D6*(('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)","v":{"$error":"#N/A"}},null,{"$f":"'RMXS Capacity'!E6*(('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)","v":{"$error":"#N/A"}},null,{"$f":"'RMXS Capacity'!G6*(('Data&Rules'!Q19)/'Data&Rules'!N19)","v":{"$error":"#N/A"}},null,{"$f":"'RMXS Capacity'!H6*(('Data&Rules'!Q19)/'Data&Rules'!N19)","v":{"$error":"#N/A"}},null,{"$f":"E109+I109","v":{"$error":"#N/A"}},{"$f":"G109+K109","v":{"$error":"#N/A"}}]
[]
[]
[]
[null,"Additional Refrigerant Charge Calculation",null,null,null,null,null,null,"IU",null,null,"BP boxes","Refnets","Total","Add'l Ref Calc"]
[null,null,null,null,"Piping Length of 1/4 liquid",null,null,null,{"$f":"R19","v":0},null,null,{"$f":"IF(P46>17000,0,R46)+IF(P47>17000,0,R47)+IF(P48>17000,0,R48)","v":0},"N/A",{"$f":"I114+L114","v":0},{"$f":"N114*N115+N116*N117","v":0.59039999999999992}]
[null,null,null,null,"1/4 multiplier",null,null,1.4999999999999999E-2,null,null,null,null,null,{"$f":"H115","v":1.4999999999999999E-2}]
[null,null,null,null,"Piping length of 3/8 liquid",null,null,null,"N/A",null,null,{"$f":"IF(P46>17000,R46,0)+IF(P47>17000,R47,0)+IF(P48>17000,R48,0)","v":0},{"$f":"R55+R56","v":16.399999999999999},{"$f":"L116+M116","v":16.399999999999999}]
[null,null,null,null,"3/8 multiplier",null,null,3.5999999999999997E-2,null,null,null,null,null,{"$f":"H117","v":3.5999999999999997E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,"Selection Flow Chart"]

{"sheet":"RMXS Capacity","index":2,"n_rows":88,"n_cols":15,"rows_kept":88,"cut":false,"hidden":true,"merged":[[2,3,2,4],[2,6,2,7],[0,3,0,6]]}
[null,null,null,"RMXS48LVJU Capacity Table"]
[]
[null,null,"Model","CTXS, FTXS (Non Ducted)",null,null,"CDXS, FDXS (Ducted)",null,null,null,null,"Efficiency"]
[null,null,null,"Cooling Capacity @ 95/67","Heating Capacity @43/70",null,"Cooling Capacity @ 95/67","Heating Capacity @43/70",null,null,"Type","SEER","HSPF","EER","COP"]
[null,"Selected CR%","Combination (%)","Cooling Cap","Heating Cap",null,"Cooling Cap","Heating Cap"]
[null,{"$f":"'Data&Rules'!D109","v":0},{"$f":"VLOOKUP($B$6,$C$8:$H$88,1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$6,$C$8:$H$88,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$6,$C$8:$H$88,3)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP($B$6,$C$8:$H$88,5)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B$6,$C$8:$H$88,6)","v":{"$error":"#N/A"}},null,{"$f":"IF((('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)=1,J8,IF((('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)=  0,J10,J9))","v":{"$error":"#DIV/0!"}},{"$f":"IF((('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)=1,K8,IF((('Data&Rules'!N19-'Data&Rules'!Q19)/'Data&Rules'!N19)=  0,K10,K9))","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($J$6,$J$8:$O$10,3)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($J$6,$J$8:$O$10,4)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($J$6,$J$8:$O$10,5)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($J$6,$J$8:$O$10,6)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,0.5,24,29,null,24,29,null,1,"Non-Ducted",18.8,11.3,10.3,3]
[null,null,0.51,24.48,29.5,null,24.48,29.5,null,2,"Mixed",16.5,10.5,9.8000000000000007,2.9]
[null,null,0.52,24.96,30,null,24.96,30,null,3,"Ducted",14.1,9.6,9.3000000000000007,2.7]
[null,null,0.53,25.44,30.5,null,25.44,30.5]
[null,null,0.54,25.92,31,null,25.92,31]
[null,null,0.55000000000000004,26.4,31.5,null,26.4,31.5]
[null,null,0.56000000000000005,26.88,32,null,26.88,32]
[null,null,0.56999999999999995,27.36,32.5,null,27.36,32.5]
[null,null,0.57999999999999996,27.84,33,null,27.84,33]
[null,null,0.59,28.32,33.5,null,28.32,33.5]
[null,null,0.6,28.8,34,null,28.8,34]
[null,null,0.61,29.28,34.5,null,29.28,34.5]
[null,null,0.62,29.76,35,null,29.76,35]
[null,null,0.63,30.240000000000002,35.5,null,30.240000000000002,35.5]
[null,null,0.64,30.720000000000002,36,null,30.720000000000002,36]
[null,null,0.65,31.200000000000003,36.5,null,31.200000000000003,36.5]
[null,null,0.66,31.68,37,null,31.68,37]
[null,null,0.67,32.160000000000004,37.5,null,32.160000000000004,37.5]
[null,null,0.68,32.64,38,null,32.64,38]
[null,null,0.69,33.120000000000005,38.5,null,33.120000000000005,38.5]
[null,null,0.7,33.6,39,null,33.6,39]
[null,null,0.70999999999999897,34.08,39.5,null,34.08,39.5]
[null,null,0.71999999999999897,34.56,40,null,34.56,40]
[null,null,0.72999999999999898,35.04,40.5,null,35.04,40.5]
[null,null,0.74,35.520000000000003,41,null,35.520000000000003,41]
[null,null,0.75,36,41.5,null,36,41.5]
[null,null,0.76,36.479999999999997,42,null,36.479999999999997,42]
[null,null,0.77,36.96,42.5,null,36.96,42.5]
[null,null,0.78,37.44,43,null,37.44,43]
[null,null,0.79,37.92,43.5,null,37.92,43.5]
[null,null,0.8,38.4,44,null,38.4,44]
[null,null,0.81,38.879999999999995,44.5,null,38.879999999999995,44.5]
[null,null,0.82,39.36,45,null,39.36,45]
[null,null,0.83,39.840000000000003,45.5,null,39.840000000000003,45.5]
[null,null,0.84,40.32,46,null,40.32,46]
[null,null,0.85,40.799999999999997,46.5,null,40.799999999999997,46.5]
[null,null,0.86,41.28,47,null,41.28,47]
[null,null,0.87,41.760000000000005,47.5,null,41.760000000000005,47.5]
[null,null,0.88,42.24,48,null,42.24,48]
[null,null,0.89,42.72,48.5,null,42.72,48.5]
[null,null,0.9,43.2,49,null,43.2,49]
[null,null,0.91,43.68,49.5,null,43.68,49.5]
[null,null,0.92,44.160000000000004,50,null,44.160000000000004,50]
[null,null,0.93,44.64,50.5,null,44.64,50.5]
[null,null,0.94,45.120000000000005,51,null,45.120000000000005,51]
[null,null,0.95,45.6,51.5,null,45.6,51.5]
[null,null,0.96,46.08,52,null,46.08,52]
[null,null,0.97,46.56,52.5,null,46.56,52.5]
[null,null,0.98,47.04,53,null,47.04,53]
[null,null,0.99,47.52,53.5,null,47.52,53.5]
[null,null,1,48,54,null,48,54]
[null,null,1.01,48.2,54.1,null,48.1,54.05]
[null,null,1.02,48.4,54.2,null,48.2,54.1]
[null,null,1.03,48.6,54.3,null,48.3,54.15]
[null,null,1.04,48.8,54.4,null,48.4,54.2]
[null,null,1.05,49,54.5,null,48.5,54.25]
[null,null,1.06,49.2,54.6,null,48.6,54.3]
[null,null,1.07,49.4,54.7,null,48.7,54.35]
[null,null,1.08,49.6,54.8,null,48.8,54.4]
[null,null,1.0900000000000001,49.8,54.9,null,48.9,54.45]
[null,null,1.1000000000000001,50,55,null,49,54.5]
[null,null,1.1100000000000001,50.14,55.1,null,49.1,54.55]
[null,null,1.1200000000000001,50.28,55.2,null,49.2,54.6]
[null,null,1.1299999999999999,50.42,55.3,null,49.3,54.65]
[null,null,1.1399999999999999,50.56,55.4,null,49.4,54.7]
[null,null,1.1499999999999999,50.7,55.5,null,49.5,54.75]
[null,null,1.1599999999999999,50.839999999999996,55.6,null,49.6,54.8]
[null,null,1.17,50.98,55.7,null,49.7,54.85]
[null,null,1.18,51.12,55.8,null,49.8,54.9]
[null,null,1.19,51.26,55.9,null,49.9,54.95]
[null,null,1.2,51.4,56,null,50,55]
[null,null,1.21,51.47,56.1,null,50.1,55.05]
[null,null,1.22,51.54,56.2,null,50.2,55.1]
[null,null,1.23,51.61,56.3,null,50.3,55.15]
[null,null,1.24,51.68,56.4,null,50.4,55.2]
[null,null,1.25,51.75,56.5,null,50.5,55.25]
[null,null,1.26,51.82,56.6,null,50.6,55.3]
[null,null,1.27,51.89,56.7,null,50.7,55.35]
[null,null,1.28,51.96,56.8,null,50.8,55.4]
[null,null,1.29,52.03,56.9,null,50.9,55.45]
[null,null,1.3,52.1,57,null,51,55.5]

{"sheet":"Results","index":3,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,0,1,4],[34,1,34,4]]}
[]
["Results"]
[]
[null,"Outdoor Unit"]
[null,"Model","Qty","Description"]
[null,"RMXS48LVJU",1,"8 Zone Multi Split CU"]
[]
[]
[]
[null,"Indoor Unit"]
[null,"Model","Quantity","Description",null,null,null,null,null,null,null,"Row Labels","Count of Selected  IU","Model","Description"]
[null,"FDXS12LVJU",1,"Slim Ducted Unit ",null,null,null,null,null,null,null,1,6,{"$f":"IF(OR(M12=\"\",L12=\"Grand Total\"),0,VLOOKUP(L12,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L12,'Data&Rules'!$A$2:$G$30,7)","v":"."}]
[null,"CDXS18LVJU",1,"Slim Ducted Unit ",null,null,null,null,null,null,null,3,1,{"$f":"IF(OR(M13=\"\",L13=\"Grand Total\"),0,VLOOKUP(L13,'Data&Rules'!$A$2:$G$30,2))","v":"Ducted- FDXS12LVJU"},{"$f":"VLOOKUP(L13,'Data&Rules'!$A$2:$G$30,7)","v":"Slim Ducted Unit "}]
[null,null,null,null,null,null,null,null,null,null,null,5,1,{"$f":"IF(OR(M14=\"\",L14=\"Grand Total\"),0,VLOOKUP(L14,'Data&Rules'!$A$2:$G$30,2))","v":"Ducted- CDXS18LVJU"},{"$f":"VLOOKUP(L14,'Data&Rules'!$A$2:$G$30,7)","v":"Slim Ducted Unit "}]
[null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,{"$f":"IF(OR(M15=\"\",L15=\"Grand Total\"),0,VLOOKUP(L15,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L15,'Data&Rules'!$A$2:$G$30,7)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total",8,{"$f":"IF(OR(M16=\"\",L16=\"Grand Total\"),0,VLOOKUP(L16,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L16,'Data&Rules'!$A$2:$G$30,7)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M17=\"\",L17=\"Grand Total\"),0,VLOOKUP(L17,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L17,'Data&Rules'!$A$2:$G$30,7)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M18=\"\",L18=\"Grand Total\"),0,VLOOKUP(L18,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L18,'Data&Rules'!$A$2:$G$30,7)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M19=\"\",L19=\"Grand Total\"),0,VLOOKUP(L19,'Data&Rules'!$A$2:$G$30,2))","v":0},{"$f":"VLOOKUP(L19,'Data&Rules'!$A$2:$G$30,7)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M20=\"\",L20=\"Grand Total\"),0,VLOOKUP(L20,'Data&Rules'!$A$2:$G$30,2))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(M21=\"\",L21=\"Grand Total\"),0,VLOOKUP(L21,'Data&Rules'!$A$2:$G$30,2))","v":0}]
[]
[]
[null,"BP Units"]
[null,"Model",null,"Description",null,null,null,null,null,null,null,"Row Labels","Count of Selected Port","Model","Description"]
[null,"BPMKS048A2U",1,"2 zone BP Box",null,null,null,null,null,null,null,1,2,{"$f":"IF(OR(M26=\"\",L26=\"Grand Total\",L26=1),0,VLOOKUP(L26,'Data&Rules'!A45:K48,2))","v":0},{"$f":"VLOOKUP(L26,'Data&Rules'!$A$46:$K$48,10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,2,1,{"$f":"IF(OR(M27=\"\",L27=\"Grand Total\",L27=1),0,VLOOKUP(L27,'Data&Rules'!A46:K49,2))","v":"BPMKS048A2U"},{"$f":"VLOOKUP(L27,'Data&Rules'!$A$46:$K$48,10)","v":"2 zone BP Box"}]
[null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,{"$f":"IF(OR(M28=\"\",L28=\"Grand Total\",L28=1),0,VLOOKUP(L28,'Data&Rules'!A47:K50,2))","v":0},{"$f":"VLOOKUP(L28,'Data&Rules'!$A$46:$K$48,10)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total",3,{"$f":"IF(OR(M29=\"\",L29=\"Grand Total\",L29=1),0,VLOOKUP(L29,'Data&Rules'!A48:K51,2))","v":0},{"$f":"VLOOKUP(L29,'Data&Rules'!$A$46:$K$48,10)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Refnet",null,null,null,null,null,null,null,null,null,"Row Labels","Count of Model",null,"Description"]
[null,null,null,null,null,null,null,null,null,null,null,"(blank)",null,{"$f":"IF(L33=\"(blank)\",\"\",L33)","v":""},"Refnet"]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total"]
[null,"Material List"]
[null,"Model","Qty","Description"]

{"sheet":"Report","index":4,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,2,30,20],[31,2,31,20],[32,2,33,20],[6,19,6,20],[26,5,26,6],[22,5,22,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[9,17,10,20],[11,5,11,6],[9,8,10,14],[17,8,17,10],[17,11,17,14],[21,5,21,6],[16,5,16,6],[7,19,7,20],[15,5,15,6],[4,14,4,16],[5,4,5,7],[5,11,5,16],[6,4,6,7],[7,4,7,7],[6,11,6,16],[7,11,7,16],[9,2,10,6],[11,2,11,3],[19,5,19,6],[20,5,20,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[17,5,17,6],[18,5,18,6]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Produced on",{"$f":"TODAY()","v":"2020-04-21"},null,null,"with Daikin 8 Zone Multi Split Selection Tool"]
[null,null,"Project Name",null,null,null,null,null,null,"Client Name"]
[null,null,"Project Address",null,null,null,null,null,null,"Client Address",null,null,null,null,null,null,null,null,"Revision"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference"]
[]
[null,null,"Material List",null,null,null,null,null,"Selection Details",null,null,null,null,null,null,null,null,"Selection Criteria"]
[]
[null,null,"Model",null,"Qty","Description"]
[null,null,{"$f":"IF(Results!B37=\"\",\"\",Results!B37)","v":""},null,{"$f":"IF(Results!C37=\"\",\"\",Results!C37)","v":""},{"$f":"IF(Results!D37=\"\",\"\",Results!D37)","v":""},null,null,{"$f":"Selection!B20","v":"Total number of Indoor Units"},null,null,null,null,{"$f":"Selection!F20","v":" "},null,null,null,"Cooling"]
[null,null,{"$f":"IF(Results!B38=\"\",\"\",Results!B38)","v":""},null,{"$f":"IF(Results!C38=\"\",\"\",Results!C38)","v":""},{"$f":"IF(Results!D38=\"\",\"\",Results!D38)","v":""},null,null,{"$f":"Selection!B21","v":"Total IU Capacity"},null,null,null,null,{"$f":"Selection!E21","v":" "},"MBH",null,null,"Indoor","80° FDB - 67° FWB"]
[null,null,{"$f":"IF(Results!B39=\"\",\"\",Results!B39)","v":""},null,{"$f":"IF(Results!C39=\"\",\"\",Results!C39)","v":""},{"$f":"IF(Results!D39=\"\",\"\",Results!D39)","v":""},null,null,{"$f":"Selection!B22","v":"Available Cooling Capacity"},null,null,null,null,{"$f":"Selection!E22","v":" "},"MBH",null,null,"Outdoor","95° FDB"]
[null,null,{"$f":"IF(Results!B40=\"\",\"\",Results!B40)","v":""},null,{"$f":"IF(Results!C40=\"\",\"\",Results!C40)","v":""},{"$f":"IF(Results!D40=\"\",\"\",Results!D40)","v":""},null,null,{"$f":"Selection!B23","v":"Available Heating Capacity"},null,null,null,null,{"$f":"Selection!E23","v":" "},"MBH"]
[null,null,{"$f":"IF(Results!B41=\"\",\"\",Results!B41)","v":""},null,{"$f":"IF(Results!C41=\"\",\"\",Results!C41)","v":""},{"$f":"IF(Results!D41=\"\",\"\",Results!D41)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Heating"]
[null,null,{"$f":"IF(Results!B42=\"\",\"\",Results!B42)","v":""},null,{"$f":"IF(Results!C42=\"\",\"\",Results!C42)","v":""},{"$f":"IF(Results!D42=\"\",\"\",Results!D42)","v":""},null,null,"Cooling Efficiency",null,null,"Heating Efficiency",null,null,null,null,null,"Indoor","70° FDB"]
[null,null,{"$f":"IF(Results!B43=\"\",\"\",Results!B43)","v":""},null,{"$f":"IF(Results!C43=\"\",\"\",Results!C43)","v":""},{"$f":"IF(Results!D43=\"\",\"\",Results!D43)","v":""},null,null,"SEER",{"$f":"'RMXS Capacity'!L6","v":{"$error":"#DIV/0!"}},null,null,"HSPF",{"$f":"'RMXS Capacity'!M6","v":{"$error":"#DIV/0!"}},null,null,null,"Outdoor","47° FDB - 43° FWB"]
[null,null,{"$f":"IF(Results!B44=\"\",\"\",Results!B44)","v":""},null,{"$f":"IF(Results!C44=\"\",\"\",Results!C44)","v":""},{"$f":"IF(Results!D44=\"\",\"\",Results!D44)","v":""},null,null,"EER",{"$f":"'RMXS Capacity'!N6","v":{"$error":"#DIV/0!"}},null,null,"COP",{"$f":"'RMXS Capacity'!O6","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"IF(Results!B45=\"\",\"\",Results!B45)","v":""},null,{"$f":"IF(Results!C45=\"\",\"\",Results!C45)","v":""},{"$f":"IF(Results!D45=\"\",\"\",Results!D45)","v":""},null,null,"System Selection Type",null,null,null,null,{"$f":"'RMXS Capacity'!K6","v":{"$error":"#DIV/0!"}},null,null,null,"Allowable Height  Difference"]
[null,null,{"$f":"IF(Results!B46=\"\",\"\",Results!B46)","v":""},null,{"$f":"IF(Results!C46=\"\",\"\",Results!C46)","v":""},{"$f":"IF(Results!D46=\"\",\"\",Results!D46)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Between Outdoor and Indoor units",null,null," <= 98 ft"]
[null,null,{"$f":"IF(Results!B47=\"\",\"\",Results!B47)","v":""},null,{"$f":"IF(Results!C47=\"\",\"\",Results!C47)","v":""},{"$f":"IF(Results!D47=\"\",\"\",Results!D47)","v":""},null,null,"Selected Connection Ratio",null,null,null,null,{"$f":"Selection!F25","v":0},null,null,null,"Between Outdoor and BP units",null,null," <= 98 ft"]
[null,null,{"$f":"IF(Results!B48=\"\",\"\",Results!B48)","v":""},null,{"$f":"IF(Results!C48=\"\",\"\",Results!C48)","v":""},{"$f":"IF(Results!D48=\"\",\"\",Results!D48)","v":""},null,null,null,null,null,null,null,null,null,null,null,"Between BP and BP units",null,null," <= 49 ft"]
[null,null,{"$f":"IF(Results!B49=\"\",\"\",Results!B49)","v":""},null,{"$f":"IF(Results!C49=\"\",\"\",Results!C49)","v":""},{"$f":"IF(Results!D49=\"\",\"\",Results!D49)","v":""},null,null,{"$f":"Selection!B27","v":"Total Piping Length (Liquid)"},null,null,null,null,{"$f":"Selection!F27","v":16.399999999999999},"ft",null,null,"Between Indoor and Indoor units",null,null," <= 49 ft"]
[null,null,{"$f":"IF(Results!B50=\"\",\"\",Results!B50)","v":""},null,{"$f":"IF(Results!C50=\"\",\"\",Results!C50)","v":""},{"$f":"IF(Results!D50=\"\",\"\",Results!D50)","v":""},null,null,{"$f":"Selection!B29","v":"Add'l Ref Charge"},null,null,null,null,{"$f":"Selection!E29","v":0.59039999999999992},"lbs"]
[null,null,{"$f":"IF(Results!B51=\"\",\"\",Results!B51)","v":""},null,{"$f":"IF(Results!C51=\"\",\"\",Results!C51)","v":""},{"$f":"IF(Results!D51=\"\",\"\",Results!D51)","v":""}]
[]
[null,null,"Disclaimer of warranty"]
[null,null,"This Tool is provided on an 'AS IS' basis, without warranty of any kind, either express or implied, including but not limited to implied warranties of merchantability or fitness for a particular purpose.  Further, no warranty is made in relation to the availability, accuracy, reliability or content of the Tool."]
[]
[null,null,"This Tool may have inherent limitations, including but not limited to design faults and programming bugs. The entire risk to the quality and performance of the Tool is borne by You, and it is Your responsibility to ensure that the Tool does what You require it to do prior to using it for any purpose (other than testing it)."]
[null,null,"Daikin’s Super Multi Selection Tool is subject to continuous improvement. Daikin reserves the right to modify, update, and include additional features and programs to the Super Multi Selection Tool without notice and without incurring any obligations. Changes to the Super Multi Selection Tool  may change end results even if the end-user’s input remains the same.  It is the end user’s responsibility to come back to the Daikin to obtain and use the most recent version of the Super Multi Selection Tool."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2.2.1"]

{"sheet":"FlowChart","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"T&C","index":6,"n_rows":32,"n_cols":8,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,7,4,13],[8,2,8,17],[5,2,5,17],[10,2,10,17],[11,2,11,17],[6,2,6,17],[7,2,7,17],[13,2,13,17],[15,2,15,17],[14,4,14,6],[14,2,14,3],[31,7,31,9],[17,2,17,17],[20,2,20,17],[22,2,22,17],[24,2,24,17],[26,2,27,17],[28,2,28,17],[18,4,18,6]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Terms and Conditions of Use, Disclaimer and Copyright Notice"]
[null,null,"Please read through these terms and conditions of use, the disclaimer and the copyright notice contained herein carefully."]
[null,null,"Please read through these terms and conditions of use, the disclaimer and the copyright notice contained herein carefully."]
[null,null,"To use the Tool You must agree to be bound by the terms and conditions of use, the disclaimer and the copyright notice contained herein .   If You do not agree with all of these terms and conditions of use, the disclaimer and the copyright notice, You may not use the Tool in any manner."]
[null,null,"You further represent that You are authorized to acknowledge and accept these terms and conditions of use, the disclaimer and the copyright notice contained herein on behalf of any entity for whom You are utilizing the Tool."]
[null,null,"Usage provisions"]
[null,null,"Subject to the terms and conditions of this Agreement, permission is granted to You to use the Tool to assist in calculations used to determine the selection of Daikin equipment.    If an upgrade or update to the Tool is made, Your prior download may continue to operate or may expire over time, but it will NOT automatically update.  To receive an update will require You to request and receive an updated copy of the Tool, and You will be required to accept these terms and conditions, the disclaimer and the copyright notice again in order to receive or download the latest version of the Tool."]
[null,null,"The Tool may be downloaded and emailed for internal use to other users within Your organization.  You may not make any modifications or changes to or tamper with the Tool when emailing it internally or otherwise.  Any party receiving the Tool shall agree that he or she is subject to the requirements of this Agreement or they are not authorized to use and shall not use the Tool."]
[null,null,"Copyright"]
[null,null,"Nothing in this Agreement shall give You any rights in respect of the intellectual property of Daikin, and You acknowledge that You do not acquire any rights in respect of such intellectual property rights. This Agreement and the Tool are intended for use only by distributors, dealers and representatives of Daikin products.  The Tool is distributed only to assist with selecting products of Daikin. You are advised that the sale, lease, or rental of the Tool in any form without prior written authority from Daikin is prohibited.  Other than the internal right to distribute by email within Your organization as described above, this work may NOT be reproduced, disclosed or distributed to any person without written authorization from an officer of Daikin.  You "]
[null,null,"can apply for permission via",null,"trlhelp@daikincomfort.com"]
[null,null,"Any unauthorized reproduction, disclosure, or distribution of copies by any person of any portion of this work may be a violation of Copyright Law of the United States of America and other countries, could result in the awarding of statutory damages up to $250,000 (17 USC 504) for infringement, and may result in further civil and criminal penalties."]
[null,null,"Trade Name / Trade Marks"]
[null,null,"All Trade Names, Trade Marks, Logos and Pictures displayed through the Tool (if any) that belong to Daikin now or hereafter is/shall be the sole property of or are licensed to Daikin or its affiliate(s). Your use of the Tool should not be construed as granting, by implication or otherwise, any license or right to use any Trade Names, Trade Marks, logos and pictures displayed through the Tool (if any) without the prior written consent of Daikin."]
[null,null,"You can apply for consent via",null,"trlhelp@daikincomfort.com"]
[null,null,"No liability"]
[null,null,"When You use the Tool You acknowledge and accept that You do so at Your sole risk. You agree that under no circumstances shall You have any claim against Daikin or associated companies or their respective employees, subcontractors, agents, representatives, consultants, or installers for loss, damages, harm, injury, expense, work stoppage, loss of business information, business interruption, computer failure, viruses, or malfunction which may be suffered by You or any other party from any cause whatsoever, howsoever arising in connection with the use of the Tool even where Daikin was aware of or ought to have been aware of the potential of such loss. Damages referred to above include direct, indirect, general, special, incidental, punitive and/or consequential damages. Some jurisdictions do not allow exclusion of certain warranties or liabilities, so the above limitations or exclusions may not apply to You. The liability of Daikin in such case would be limited to the fullest extent permitted by law."]
[null,null,"Indemnity"]
[null,null,"You hereby agree to indemnify Daikin and its affiliated companies or their respective employees, subcontractors, agents, representatives, consultants and installers and hold them harmless against any and all claims, losses, damages, harms, injuries, expenses, work stoppages, loss of business information, business interruption, computer failure or malfunction which may be suffered by You or any other party whatsoever as a consequence of any act or omission of Daikin or affiliated companies, whether negligent or not, arising out of the Tool, its calculations or Your use of the Tool, howsoever arising in connection with the Tool. These provisions are binding on Your legal successors, assigns, heirs, personal representatives and administrators."]
[null,null,"Miscellaneous"]
[null,null,"Daikin reserves the right to modify from time to time these terms and conditions of use at Daikin's sole discretion and without prior notice."]
[null,null,"You are responsible for determining the terms and conditions of use in force at the time of Your use of a new version of the Tool."]
[null,null,"If any provision of this Agreement is found to be invalid or unenforceable, the invalidity or unenforceability of such provision shall not affect the other provisions of this Agreement, and all provisions not affected by such invalidity or unenforceability shall remain in full force and effect."]
[]
[null,null,"In such cases You agree that Daikin may substitute for each invalid or unenforceable provision a valid or enforceable provision which achieves to the greatest extent possible the objectives and intention of the invalid or unenforceable provision."]
[null,null,"The validity and interpretation of this Agreement will be governed by the laws of the State of Texas and any claim arising out of the Agreement shall exclusively be brought in the Federal or State Courts located in Dallas, Texas."]
[null,null,"Contact information"]
[null,null,"If You require further information or have questions, please contact us at:",null,null,null,null,"trlhelp@daikincomfort.com"]